package com.itheima.travel.mapperExt;

import com.itheima.travel.pojo.Route;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface FavoriteMapperExt {
    @Select("SELECT r.* FROM tab_route r,tab_favorite f WHERE f.route_id=r.id AND f.user_id=#{id,jdbcType=BIGINT}")
    List<Route> selectRouteByUserId(Long id);
}
